package com.ahorresas.modelo.sqls;

public class MesSql {
    String sql = "";
    
    public String buscarMes(){
        sql = "SELECT codigo, nombre "
            + "FROM MESES "
            + "WHERE codigo = ?;";
        return sql;
    }
    
    public String listarMeses(){
        sql = "SELECT codigo, nombre "
            + "FROM MESES;";
        return sql;
    }
    
    public String crearMes(){
        sql = "INSERT INTO MESES (codigo, nombre) "
            + "VALUES (?,?);";
        return sql;
    }
    
    public String modificarMes(){
        sql = "UPDATE MESES SET nombre = ? "
            + "WHERE codigo = ?;";
        return sql;
    }
    
    public String eliminarMes(){
        sql = "DELETE FROM MESES "
            + "WHERE codigo = ?;";
        return sql;
    }
}
